Quarto Basics

import pandas as pd
import polars as pl
import polars.selectors as cs

from great_tables import GT
from great_tables import GT, loc, style, md
df = pl.read_parquet(
    f"./data/arrivals_polars.parquet"
)
(GT(df)
 .fmt_integer(columns = ["n_trips"])
 .data_color(
    columns=["n_trips"],
    palette=["white", "green"],
    na_color="lightgray"
 )
 .fmt_nanoplot(
     columns = "weekday_arrivals", 
     plot_type="line",
     reference_line="mean"
 )
 .fmt_nanoplot(
     columns = "weekend_arrivals", 
     plot_type="line",
     reference_line="mean"
 )
 .cols_label(
     name = "Transit Operator",
     n_trips = "Weekly Trips",
     weekday_arrivals = "Weekday Arrivals",
     weekend_arrivals = "Weekend Arrivals",
 )
 .tab_header(
     title = "Scheduled Stop Arrivals by Hour",
     subtitle = "weekday vs weekend totals"
 )
 .tab_source_note(
     source_note = "GTFS scheduled stop_times.txt"
    )
 .tab_source_note(
    source_note = md(
        "[GTFS specification](https://gtfs.org/schedule/reference/#stop_timestxt)"
    )
 )
)
Scheduled Stop Arrivals by Hour
weekday vs weekend totals
Transit Operator Weekly Trips Weekday Arrivals Weekend Arrivals
Alhambra 539
23866000000007561054036036036036036044065566066027000000
17720000000000063727272725700000000
Amador 145
11537500000015802103752252102052902801502402151857000000
None
Anaheim Resort 51,304
5.04K9.13K06.16K5.01K000252.69K5.66K5.92K5.79K5.27K5.42K5.45K5.49K5.38K6.33K9.13K7.61K5.97K6.40K6.51K6.83K6.98K6.96K
1.99K3.60K02.44K2.00K00001.04K2.22K2.35K2.31K2.07K2.13K2.15K2.16K2.11K2.50K3.60K2.99K2.36K2.53K2.58K2.73K2.80K2.80K
Antelope Valley Transit Authority 3,272
4.19K6.76K0130005853.12K5.83K6.20K6.36K6.61K6.53K6.52K6.34K6.52K6.67K6.76K6.51K6.33K4.72K4.31K3.75K3.48K2.64K1.11K
8291.56K000000161841.31K1.46K1.54K1.52K1.50K1.46K1.49K1.51K1.50K1.56K1.50K1.44K1.00K5362661050
Arcadia 595
8919000000008013014514013015517016514018519016516013050000
29780000000018364868687858787672723220000
Artesia 33
11360000000003236262624263432262000000
6180000000001618131312131716131000000
Arvin 155
98295000001550240225280190280295210250265950000000
None
Auburn 48
1235000000000035353535353535350000000
270000000000777777770000000
B-Line 2,313
1.94K4.18K000000801.94K4.18K4.16K3.46K2.70K3.09K2.72K2.66K3.40K3.82K3.84K3.78K3.27K1.75K1.26K44940
194506000000004033641750643047541039448246244326140000
Baldwin Park 563
198410000000153104054103751202903954103902452752903503151401500
27950000000003477957762869092430000000
Banning Pass 312
941750000006013517517516517516015517016517017016010540404050
1342000000000422436341618322842301400000
Bay Area 511 AC Transit 26,129
39.3K58.4K5.22K13.5K5.72K5.44K5.22K5.84K21.1K46.8K56.7K55.1K52.5K50.8K50.7K50.7K51.7K53.6K58.4K56.8K55.3K55.4K51.4K44.5K40.5K33.9K21.8K
7.67K10.6K1.31K3.14K1.60K1.42K1.31K1.38K2.98K7.86K9.86K10.3K10.4K10.4K10.5K10.5K10.4K10.5K10.6K10.5K10.5K10.6K10.3K9.02K8.35K7.01K4.67K
Bay Area 511 ACE 40
17500000015304550402000000153550503515000
None
Bay Area 511 Angel Island-Tiburon Ferry 580
22114000000000001141080100341084824000000
26126000000000001261260118521185232000000
Bay Area 511 BART 6,681
3.22K4.41K01.70K350002853.07K4.15K4.40K4.33K4.36K4.35K4.37K4.34K4.41K4.38K4.34K4.35K4.36K4.34K4.22K3.64K2.97K2.42K2.13K
9601.46K0719143000575167261.23K1.40K1.46K1.44K1.44K1.43K1.43K1.43K1.43K1.43K1.43K1.39K1.15K977890905
Bay Area 511 Caltrain 918
53188003401000060325615685690605560580585575585645830880840690660705655540
17637307220001282176220174156128122131188192261373371307239232288283186
Bay Area 511 Capitol Corridor 524
139285000003075165215205210195170100130160230250255285215210165655
46103000004133759676462593748547989103101737058234
Bay Area 511 Commute.org 1,610
6992.38K000000151.10K2.14K2.19K1.84K4003153003356451.56K2.38K2.30K1.13K12015000
None
Bay Area 511 County Connection 6,265
6.11K13.2K00000651.43K7.70K12.9K11.5K9.33K8.15K7.47K8.03K7.83K9.51K13.2K12.9K11.5K11.6K7.42K3.71K2.31K1500
9051.99K00000002007599441.46K1.97K1.83K1.86K1.75K1.83K1.73K1.85K1.99K1.74K1.14K6741700
Bay Area 511 Dumbarton Express 445
4691.00K0000003407609459105505104505004858859851.00K995920765245000
None
Bay Area 511 Emery Go-Round 1,005
8721.52K000000901.08K1.36K1.38K1.38K1.38K1.47K1.48K1.38K1.38K1.44K1.52K1.38K1.38K1.20K8806251250
7617200000000041138147140171147165172154147147917569180
Bay Area 511 Fairfield and Suisun Transit 984
19644000000002403504003503503503503203154404103453001800000
1238000000000027383838383833310000000
Bay Area 511 Golden Gate Ferry 450
31700000000256555507050503540606070554015000
7200000000000214142020161618201262000
Bay Area 511 Golden Gate Transit 1,276
1.35K2.94K0240550402551.18K2.50K2.78K2.32K1.38K1.25K1.31K1.27K1.24K1.38K1.84K2.58K2.94K2.35K1.60K1.25K1.16K800685
346512076160650116308408488478512490484502502502506498496460414388318278
Bay Area 511 MVGO 360
145475000000011047544043518500002704604104302550000
None
Bay Area 511 Marin 4,187
3.42K6.80K021513065003103.21K6.43K6.16K5.04K4.89K5.14K5.24K5.36K6.00K6.80K6.27K5.99K4.78K3.86K3.06K1.84K855365
9511.73K0120522600682801.14K1.66K1.73K1.66K1.64K1.72K1.62K1.71K1.68K1.66K1.70K1.42K1.07K744556367190
Bay Area 511 Mission Bay 550
1745500000001515047550555034500010033041547048530030000
None
Bay Area 511 Muni 64,867
75.2K110K12.0K28.0K12.4K12.0K12.0K14.9K47.4K75.1K96.5K103K105K105K106K106K106K107K108K110K107K104K93.5K82.3K72.1K54.2K36.8K
25.4K35.8K4.81K10.8K4.95K4.81K4.81K5.51K16.4K23.4K28.1K32.0K34.3K35.0K35.3K35.7K35.8K35.7K35.7K35.8K35.7K35.0K32.4K30.1K27.2K20.6K14.1K
Bay Area 511 Petaluma 1,282
6331.46K00000006301.46K1.19K9409409409401.00K1.29K1.35K1.27K1.00K1.01K825395000
1284830000000192451483256188188188188188188188143949449000
Bay Area 511 Rio Vista Delta Breeze 40
83000000000152025255253050025550000
None
Bay Area 511 SFO AirTrain 7,343
2.40K2.50K2.11K2.34K2.11K2.11K2.38K2.50K2.46K2.46K2.46K2.46K2.34K2.32K2.32K2.46K2.46K2.46K2.46K2.46K2.46K2.34K2.32K2.43K2.46K2.46K2.46K
9581.00K8449348448449521.00K984984984984936928928984984984984984984936928972984984984
Bay Area 511 SamTrans 9,459
12.3K21.1K1.56K2.40K1.86K1.56K1.86K2.56K7.30K14.5K21.1K19.3K17.2K16.3K16.1K16.1K16.6K17.2K20.7K19.6K17.9K17.1K15.1K11.3K9.07K7.68K4.44K
3.42K5.51K6929508607066927441.03K1.75K3.41K4.69K5.12K5.29K5.33K5.38K5.40K5.41K5.44K5.47K5.51K5.36K4.56K3.30K2.40K2.02K1.28K
Bay Area 511 San Francisco Bay Ferry 889
6915000000020601501401301101258080551001301201257510050150
1234000000000416242816203422182826161610100
Bay Area 511 Santa Clara Transit 24,153
35.5K56.4K05.22K1.64K64001.36K15.4K44.5K54.7K55.1K55.4K54.4K54.4K54.4K54.4K54.5K55.7K56.4K54.9K52.7K42.3K30.5K24.4K17.7K10.4K
8.49K14.2K11.59K550133411.18K5.12K9.07K11.9K13.7K14.1K14.2K14.2K14.1K14.2K14.2K14.1K14.0K12.8K10.9K8.61K6.84K5.16K3.20K
Bay Area 511 Santa Rosa CityBus 4,318
4.23K8.93K00000003.46K5.29K5.88K6.04K8.44K8.72K8.68K8.80K8.93K8.84K8.80K6.42K5.42K5.47K2.28K5000
9922.37K00000005631.08K1.13K1.24K2.04K2.32K2.34K2.37K2.30K2.22K2.25K1.36K1.13K9974561000
Bay Area 511 SolTrans 3,198
1.85K3.63K00005902007902.93K2.92K3.33K3.26K3.32K3.38K3.32K3.13K3.63K3.45K3.32K2.90K2.49K1.52K3406030
392973000000058181380818869859878973901907906883545146932300
Bay Area 511 Sonoma County Transit 1,584
2.65K5.55K00000001.90K5.34K4.73K5.30K4.54K4.16K4.17K4.90K4.25K5.55K4.40K4.74K3.68K2.48K1.90K1.15K40540
6041.30K00000001968129731.11K9501.00K1.05K1.30K1.20K1.25K8601.12K864752728312260
Bay Area 511 Sonoma-Marin Area Rail Transit 222
952100000020801351901751301358065951052102001901701451054550
1638000000001224343438363218322824342018000
Bay Area 511 South San Francisco Shuttle 255
269590000000003755705905505505902504205855705355753000000
None
Bay Area 511 Treasure Island Ferry 215
123500000000153510201525200253010302520000
616000000004861412161229139131614200
Bay Area 511 Tri Delta 4,357
6.52K11.0K0775700357403.01K5.68K9.59K9.86K9.66K9.10K8.61K8.22K8.66K9.61K10.1K11.0K10.9K9.99K9.13K7.96K5.84K5.28K2.49K
2.07K3.35K026420112128251.41K3.00K3.31K3.35K3.18K3.07K2.98K3.09K3.26K2.95K3.01K3.23K3.00K2.73K2.49K1.93K1.64K843
Bay Area 511 Tri-Valley Wheels 2,855
2.60K5.85K000002451.06K3.04K5.55K5.84K3.74K2.90K2.79K2.83K2.84K3.58K5.85K5.72K4.94K4.45K2.90K1.72K1.43K810270
5421.04K0000002043644637578188689049338788821.04K91586789173065655026036
Bay Area 511 Union City Transit 1,856
1.71K2.89K000003702.48K2.89K2.89K2.46K2.10K2.10K2.10K2.10K2.13K2.10K2.20K2.84K2.89K2.89K2.64K1.67K1.36K7400
3176300000000384566166166166166166306166166166166163180000
Bay Area 511 Vacaville City Coach 751
7302.15K00000001251.38K2.15K1.24K1.16K1.16K1.16K1.70K1.65K1.83K1.58K1.16K1.08K1450000
982320000000042062322322322322322322322322324400000
Bay Area 511 Vine Transit 1,427
1.20K2.46K00000152201.04K2.08K2.34K2.10K2.24K2.22K2.30K2.22K2.46K2.40K2.23K2.07K1.48K85048016000
2304620000000602944494594624624594624624624623853111981052300
Bay Area 511 WestCAT 2,673
5361.04K020000253556908528877707207107407728258309831.01K1.04K93032516012590
32640000000016416160575463545655645347563520
Beach Cities GMV 564
1.06K2.15K000000151.38K2.15K1.82K1.84K1.64K1.64K1.56K1.53K1.74K1.74K2.06K1.69K1.64K1.38K1.10K47500
2935560000000120302375463556533523463507546517556534418327252400
Bear 1,732
3264650430430360700025350425415380325320320320320400425465350415430430430
76135010110397210056175795954575587106103881019912013512193
Beaumont Pass 616
2949650000001048596557557045045046543545092577032517050000
144900000000248494749104549493000000
Bell Gardens 180
31750000000156575757560557575757525000000
61500000003131515151211151515155000000
Bellflower Bus 200
501200000000011012012012012012012012012012010000000
None
Big Blue Bus 8,351
10.3K18.0K000001253.34K9.84K16.3K18.0K17.2K16.9K16.2K16.1K16.1K16.6K17.3K17.2K16.5K16.2K12.6K9.24K6.44K4.49K1.34K
2.50K4.41K000000961.26K2.61K3.38K3.98K4.19K4.28K4.24K4.41K4.29K4.39K4.34K4.29K4.05K3.30K2.58K2.08K1.68K430
Blossom Express 8
31800000000001018812186000000000
None
BruinBus 535
224495000000002603904053954954504454154904453451551951651801400
None
Burbank 495
5141.00K0000001556801.00K1.00K8806656106106106108401.00K1.00K1.00K8004902701100
None
Calabasas 102
9845000000006545022015090145132163303338165140000000
1125000000000002425252525124252525252510
Calaveras 194
6012500000003075125125120110105105105125105901158515000
4140000000000113141486141413200000
Cerritos on Wheels 252
521800000000000105180180180180180180750000000
1036000000000021363636363636150000000
Cerritos on Wheels Website 252
541850000000000105185185185185185185800000000
1137000000000021373737373737160000000
Clean Air Express 100
472650000004526526000000001102451753000000
None
Clovis 589
145305000000524530528527027027027027028030527027017000000
12380000000018323838323838321700000000
Commerce 784
9241.74K00000001.01K1.58K1.59K1.74K1.51K1.44K1.46K1.59K1.58K1.62K1.66K1.48K1.32K1.44K85029550
369698000000040663063669860457458463663464666259252857634011820
Corona 285
84180000000040180155150165160170160170170155170155150000
1134000000000332333434343432182000000
County Express 181
4612000000154050951008060355555591021207055303530150
None
Cudahy 77
1840000000004040404040404040404040000000
716000000001616161616161616161616000000
Culver City 5,925
6.43K11.5K03000001.91K7.18K10.1K10.6K10.7K11.0K9.66K9.45K11.5K10.2K11.1K10.3K9.46K9.31K8.18K5.59K4.57K2.97K654
1.39K3.36K01200006009311.16K1.77K1.85K2.24K2.33K2.47K3.36K2.58K2.10K2.13K2.17K1.90K1.88K1.48K1.13K738425
Curry Public Transit 66
166500000002025303030352030652510205000000
313000000045666746135241000000
Delano 320
227680000000006806806803403403403406806806800000000
None
Desert Roadrunner GMV 265
98265000000159023118623923826523024922118713653000000
21300000001315756100000000000
Desert Roadrunner 227
99260000000159022618123423326023026023419814468500000
11000000000051086400000000000
DowneyLINK GMV 230
274960000000051584557027529027530528058096077558532000000
None
Eastern Sierra 3,234
7891.49K03303300000251.01K1.42K1.48K1.46K1.44K1.47K1.49K1.49K1.45K1.46K1.25K575527491491395330
306572013213200002378550572572572572572572572572490214196196196158132
El Dorado 534
285650000000353156355055404754754754754806106505654751155000
1133000000000033333333333333330000000
El Monte 765
2395200000001053105204303753954303903753904654654754451600000
47132000000000086132126132126132126132126000000
El Segundo 35
3300000000000001530205000000000
None
Elk Grove 1,386
1.60K4.04K00000103203.18K3.88K2.38K2.17K2.27K2.19K2.17K2.27K2.28K2.92K4.04K3.44K2.13K1.86K720220250
952120000000281672121961942121961942121961942126000000
Flixbus 6,448
1.21K1.76K5051.33K1.13K1.03K1.14K8277076555085056086711.00K1.16K1.32K1.43K1.64K1.60K1.70K1.68K1.73K1.76K1.72K1.74K1.46K
515761215574485445492353298271215216258282414479558613696680718704750761729735634
Foothill 7,888
10.7K16.9K1291.57K4471291412.18K9.32K14.9K16.1K16.9K15.6K14.1K13.5K13.5K14.0K14.9K16.1K16.4K16.5K16.3K14.3K11.7K9.15K6.36K3.49K
3.03K4.88K403361354140556602.73K4.33K4.58K4.74K4.57K4.45K4.45K4.67K4.81K4.88K4.84K4.81K4.57K3.89K2.98K2.72K2.30K1.14K
Fresno County 202
5919000000005155851501551156512513515019085000000
170000000002762001771000000
Fresno 8,470
13.4K21.8K08500003.00K19.7K21.7K21.6K21.6K21.6K21.6K21.3K21.3K21.3K21.5K21.8K21.8K19.7K14.6K12.9K9.81K3.34K1.40K
3.40K6.72K017000001.46K5.44K6.56K6.61K6.59K6.65K6.66K6.68K6.69K6.72K6.68K6.67K5.68K1.39K280279280280
G Trans 2,804
5.50K11.4K000007062.88K7.16K9.21K9.11K8.39K9.73K10.7K9.40K11.4K9.07K8.74K8.51K10.3K7.44K4.86K2.88K1.54K90
1.19K2.78K00000567701.36K1.66K2.08K1.78K2.37K2.62K1.80K2.04K1.63K1.86K1.78K2.78K1.77K1.03K91625300
GET 3,998
4.89K10.1K0500510407458.15K10.1K9.84K9.90K9.76K9.79K9.76K9.84K9.91K10.1K9.84K8.68K8404501030
1.92K3.94K00000002943.14K3.88K3.89K3.88K3.89K3.91K3.94K3.93K3.89K3.88K3.90K3.34K3080000
Get Around Town Express 12
12002000000000000000000000000
040400000000000000000000000
Glendale 1,707
4161.02K000000566361.02K89278869269268468872487681278050811232400
611870000000000128187183158180181168171931300000
Glendora 357
4713200000088128132120360078261097212012012048000
None
Glenn 66
7819500000006590120170601951201951201951201901158030000
8220000000002215179221517922151790000
Go West 350
11324000000001102352352352402352352402352352401607500000
None
Grapeline 138
735850000000295585115000002053701750000000
4480000000030481800000000000000
Guadalupe Flyer 352
921700000000100170170170170170170170170170170170170700000
3368000000020345468686868686868686848140000
Havasu Landing Ferry 246
1420020440005202051020202020202020202020202020
680844000288248888888888888
Humboldt 839
1.06K2.10K000000854902.00K2.01K2.02K1.96K1.83K1.80K1.76K1.76K2.08K2.03K2.10K1.30K805765450900
7819100000000378215618517916118617318519110510356532000
Huntington 173
194500000002530453030453045303045303500000
390000000005696696965200000
Imperial Valley Transit 751
4681.00K000000805687228689018617707708391.00K9138877984813701154019540
5311300000034710311395919285101971129883815620000
Kern 582
16632900005231361642762422872371922152262733232233292553041401141310
25580000221682534485857534835354154432911240
Kings 1,977
1.49K3.38K00000008552.02K2.06K2.58K3.28K3.38K3.28K3.22K3.38K3.32K2.96K2.02K1.90K1.44K150000
251675000000010726029739261267565162359955948528126817828000
LA DOT 19,380
21.4K40.2K00000203.28K33.2K40.2K36.0K33.1K32.6K32.6K32.9K33.5K34.5K35.6K38.0K39.8K37.4K26.9K14.3K7.38K1.66K80
4.80K11.0K0000004901.30K1.68K1.78K9.01K10.9K10.9K11.0K10.9K11.0K10.9K10.9K10.9K7.21K2.07K1.84K1.60K64228
LA Metro Bus 89,841
180K281K23.1K49.5K33.1K24.9K23.1K52.1K155K257K279K272K256K251K250K250K251K258K274K281K272K243K186K139K104K83.9K64.7K
52.5K77.4K9.11K19.7K13.2K9.96K9.11K14.5K34.9K58.5K68.3K72.9K75.9K77.0K77.2K77.0K77.3K77.2K77.4K77.2K75.6K68.6K56.9K46.8K37.7K32.4K25.6K
LA Metro Rail 8,568
5.32K7.78K22.24K36323403.32K5.09K7.12K7.78K7.52K6.92K6.54K6.55K6.54K6.60K7.11K7.64K7.72K7.73K7.67K7.03K5.28K3.86K3.46K3.35K
1.79K2.58K087613201201.13K1.38K1.42K1.75K2.32K2.47K2.47K2.47K2.47K2.48K2.54K2.58K2.58K2.58K2.58K2.43K1.92K1.56K1.45K1.38K
LADPW 2,949
2.82K5.42K0000002952.43K4.85K5.24K5.16K5.34K5.38K5.16K5.38K5.42K5.30K5.12K5.08K3.28K2.08K1.34K44926945
5511.31K00000012481443461.19K1.27K1.28K1.24K1.31K1.29K1.27K1.24K96347329326926926945
LAX FlyAway 1,519
394495100435210100140180260430450450450450450450450450450450450450450450450450495
1581984017484405672104172180180180180180180180180180180180180180180180180198
La Campana 99
26550000000055505550555055505550555000000
3110000000000001110111011100000000
La Puente 164
54100000000090100100100100100100100100100100100100100000
14400000000000364040404040404022200000
Laguna Beach 1,302
7819000000000701701701901701901601551801741325220241660
43100000000000076921009210092100921008845212060
Lake 655
23446500000065235360395435465465395380430420430450360220903000
217600000000112160657651486663410000000
Lassen Flex 54
16600000003555601000025402035103550150000
160000000004540000653000000
Lassen 177
54160000000355595504070120145160140145507590200000
41400000000011131288881463000000
Lawndale Beat GMV 194
1523600000000026536030533531032534532032032531012000000
4413800000000027821241241301381281289786000000
Lawndale 388
1613850000000028038532535533034537034034034533012500000
47148000000000298813213213814813613610291000000
Long Beach 11,897
19.0K30.7K0000026014.8K24.7K29.2K30.2K29.2K29.0K28.4K28.9K29.3K30.6K30.7K30.5K28.3K27.3K22.4K15.7K12.7K10.9K3.42K
5.13K8.18K0000072.57K4.78K6.48K7.43K7.95K7.98K8.18K8.17K8.12K8.12K8.16K8.15K8.10K7.66K6.69K5.24K4.28K3.76K1.26K
Lynwood 489
37885500000004357958457256508208558308507707607053500000
11234400000002656192322302260304304344312194561400000
Madera County Connection 156
51133000000525100133119906010510998709510580355000
None
Madera Metro 561
38185500000000485760855855855855855855855855770285100000
3411800000000008011811811811811899380000000
Manteca 403
2975650000000555565540540540540540540540540540560560200000
248400000000008484848484848400000000
Maywood 90
73185000000001801751701801601801701751851755000000
9370000000000343632363337100000000
Mendocino 648
5501.36K00000003009901.06K9851.12K1.15K1.22K1.12K1.11K1.36K1.36K1.09K280550000
3393000000016106281938180837389633614120000
Merced GMV 2,619
6911.37K000000405551.01K1.20K1.28K1.33K1.32K1.32K1.37K1.32K1.34K1.32K1.31K945745180000
1873970000001211324832435437836837239735936137835523119441000
Merced 1,941
5791.03K000000406351.01K1.02K1.01K1.02K1.03K1.03K1.02K1.03K1.03K1.02K1.01K930820210000
84206000000034114918820018619020618319619518562206000
Metrolink 1,162
4019050501501526054080085074549535019525032044060085090571551527018516585
801620000001036921261521021221281161561621561541187874644026
Montebello 2,158
4.27K6.88K000001.16K4.12K6.58K6.86K6.88K6.59K6.56K6.62K6.52K6.51K6.52K6.61K6.58K6.05K6.28K6.22K4.54K1.42K00
1.35K2.17K000002731.38K2.17K2.06K1.95K2.04K2.07K2.07K2.03K2.04K2.05K2.06K2.09K2.08K2.08K2.04K1.39K50520
Monterey Salinas 6,247
4.74K8.68K0000006003.72K7.48K8.41K8.47K8.62K8.59K8.50K8.49K8.65K8.68K8.56K8.34K6.78K3.86K2.88K2.76K3450
1.16K2.42K00000001221.28K1.99K2.18K2.31K2.37K2.38K2.37K2.42K2.36K2.35K2.24K1.92K1.04K40214400
Morongo Basin 458
1242600000000902552402252302302002152102052302605210596110200
112800000000671927232019212228202287810
Mountain Transit 1,144
250529000000552002952824065145024424844955294613553703052654000
851770000005649697128175176165170177173166125128102861600
Needles 67
921850000000018518518518518518518518518518518518500000
113700000000000373737373737370000000
Nevada County 612
28863000000053055354605854254605455305454705604506304100000
339000000000488085888482819077760000000
North County 8,650
9.93K16.4K0420002.88K9.74K14.9K16.4K16.3K15.2K14.0K14.0K13.8K14.3K15.0K16.2K16.2K15.5K13.9K11.6K8.16K5.73K3.24K1.08K
2.48K4.18K0240001201.20K2.52K3.33K3.73K4.05K4.04K4.16K4.07K4.18K4.09K4.10K3.97K3.85K3.49K3.00K2.32K1.68K1.06K481
Norwalk Avail 1,549
2.44K4.04K0000108402.22K3.73K3.86K4.00K3.76K4.04K3.76K3.86K3.74K3.97K3.78K3.96K4.00K3.64K2.66K1.72K7503700
322749000000241592895186827327367247497427377034643191540000
OCTA 19,673
37.9K58.9K05.62K1.80K021512.9K40.0K54.9K58.8K56.7K54.1K51.5K51.5K50.9K51.4K53.2K58.4K58.9K56.0K50.9K44.7K38.2K30.6K19.1K9.60K
9.85K15.6K131.66K65313171.60K5.61K10.2K13.3K14.2K15.0K15.4K15.6K15.6K15.6K15.4K15.2K15.4K15.2K13.9K12.5K10.3K7.26K4.38K2.40K
OmniTrans 8,647
13.9K22.1K00001754.01K11.5K17.0K19.5K19.3K19.7K20.4K20.8K21.5K21.7K22.1K21.9K22.0K22.0K20.7K17.5K14.3K11.1K4.73K640
3.18K5.81K00000224863.14K4.95K5.66K5.69K5.56K5.61K5.66K5.66K5.64K5.64K5.65K5.81K5.14K3.35K1.66K74015834
Oregon POINT 126
318501000001010203550608560405030357055555510105
133404000044814202434241620121428222222442
Palos Verdes PTA 570
202830000000042083057320193859010743381666842474250000
None
Pasadena 4,910
4.75K10.2K0000004653.84K6.46K9.30K8.38K9.57K10.2K8.94K8.17K8.44K9.57K9.31K6.58K7.26K6.90K700000
1.98K4.56K0000001301.09K2.06K2.91K2.90K3.39K4.30K4.12K4.20K4.28K4.52K4.56K3.08K2.97K2.66K295000
Placer 655
28060500000409029560548647448547048547049853254041528426016611900
39970000000021869497949794979483548240000
Plumas 170
127265000000013525513514022311826521513124513026023514018023000
None
PresidiGo 344
197480000000301754204803652702702702702703054204804003050000
4413600000000004256136136136136136136964200000
Redding 1,677
1.09K2.16K0000052201.32K2.06K2.06K1.80K2.16K1.83K2.01K1.98K2.04K2.12K2.08K1.85K2.08K58045000
1674150000000431672504103613993734043974123654151159000
Redwood Coast l 329
9723500000004522519522017517518019118821123520045305000
9280000000522228191920212019218961000
Riverside 7,653
11.7K20.5K0180002754.02K9.38K12.5K15.5K17.4K18.3K20.5K20.4K19.0K18.9K18.3K17.8K18.8K17.2K16.3K14.1K10.3K6.43K3.50K950
2.92K5.37K0280006768362.13K3.93K5.00K5.29K5.25K5.37K4.88K5.19K5.06K4.81K4.94K4.98K4.76K3.64K1.80K1.01K394165
Rosemead Passio 168
6411000000001101101101101101101101101101101101101101100000
134400000000000444444444444440000000
Roseville 799
1745150000003537547032522020022522022521036051537018080808500
9230000000032023232323232323232000200
SBMTD 9,395
6.98K13.0K036800007727.17K12.2K12.4K11.6K10.2K9.98K11.3K12.4K11.6K13.0K12.1K11.5K9.30K7.66K5.09K4.08K3.12K1.64K
1.46K3.13K000000305661.47K2.29K2.48K2.80K2.49K2.69K3.13K2.78K2.65K2.65K2.84K2.35K1.53K1.00K75039158
SLO 811
8201.56K00000007851.32K1.24K1.34K1.56K1.54K1.31K1.42K1.38K1.46K1.42K1.32K1.07K7997697551900
1272520000000506422025024423425224423425024423425024426000
SLORTA 2,052
1.65K3.54K00000001.17K2.46K2.92K2.84K3.04K2.50K3.54K2.88K3.22K2.98K3.14K3.05K3.11K1.54K800315150
5521.31K00000002987519409801.12K8631.31K9611.07K9881.12K1.10K9744012858860
Sacramento 14,925
18.9K32.3K027000457557.14K24.7K32.3K30.4K27.7K27.3K27.4K27.5K27.4K29.2K32.0K31.6K31.5K28.8K23.8K20.2K14.7K6.49K1.09K
4.28K7.83K054000282851.18K4.30K6.23K6.88K7.39K7.65K7.71K7.83K7.80K7.74K7.78K7.54K7.13K6.26K4.90K2.85K908195
Sage Stage 14
4200000000042011992131111116000000
None
San Diego 46,499
47.5K76.0K906.56K2.16K665906.89K36.2K65.0K73.9K74.4K72.0K70.0K69.9K69.5K69.4K71.6K75.5K76.0K74.8K67.6K49.3K38.0K32.1K25.2K14.2K
9.74K15.9K111.49K410113114333.80K9.60K12.7K13.7K14.5K15.2K15.6K15.7K15.8K15.9K15.9K15.9K15.3K14.0K12.2K10.1K7.44K4.74K3.15K
San Joaquin 6,939
4.56K9.04K00000157004.76K8.98K8.46K7.76K7.76K7.56K7.55K7.58K7.76K8.60K9.04K7.84K7.02K4.80K2.18K875950
3017160000000094388716691683664682654658628622536156282620
San Pedro Trolley 64
21200000000000000000001012121220
1860000000000000050606060606034328000
Santa Clarita 5,554
7.49K15.2K00000101.38K3.88K11.6K12.9K12.1K12.2K12.6K12.6K12.8K13.5K15.2K13.8K13.3K12.3K10.9K5.62K2.42K4150
2.57K5.18K0000003579393.85K4.81K4.43K4.53K4.47K4.36K4.40K4.84K5.18K4.39K4.47K4.43K3.84K1.72K577780
Santa Cruz 3,896
5.54K9.46K01.16K000101.01K5.33K8.04K8.34K8.25K8.42K8.10K8.15K7.92K7.76K9.17K9.46K9.41K8.34K6.92K6.32K4.38K3.65K2.89K
1.54K2.68K0140000004681.35K1.97K2.26K2.32K2.34K2.62K2.51K2.64K2.56K2.68K2.63K2.64K2.20K2.15K1.39K1.18K812
Santa Maria 1,339
1.14K2.37K000000301.13K2.13K2.37K1.98K1.85K2.12K2.00K1.84K2.14K2.21K1.94K2.15K1.68K1.42K305000
27474000000000021668061872466861273474063272622400000
Santa Ynez Mecatran 432
173405000000014540531532530037540524536040523536027050000
358100000002981636560758149728147725410000
Sierra Madre 40
242150000000000002151851800000000000
None
Siskiyou 185
1203700000000801452051551653203703501853451251751705530000
None
South County Transit Link 120
441650000004070165857050557050406512510555150000
None
Spirit Bus Passio 525
10724000000001502052401902201952201952052202302059000000
None
StanRTA 2,084
2.62K4.38K00006185762.84K4.19K4.34K4.36K4.36K4.37K4.36K4.36K4.36K4.36K4.36K4.38K4.19K3.10K2.12K1.50K78044
None
Stanford 3,422
1.67K3.98K022500058152.06K3.65K3.96K2.92K1.98K1.80K1.78K1.74K1.78K3.32K3.98K3.93K2.86K1.40K1.14K333239265
681260840000000068126126126126126126126126126580968496
SunLine Avail 3,088
3.24K5.64K0000001.64K4.04K5.30K5.36K4.84K4.76K4.46K4.24K4.22K4.72K5.06K5.64K5.01K5.12K4.66K4.03K3.18K1.40K20
1.09K1.67K0000005241.30K1.64K1.64K1.57K1.55K1.57K1.55K1.57K1.63K1.62K1.64K1.64K1.67K1.66K1.55K1.29K5808
TART, North Lake Tahoe 884
346735030150000435635690695710670735680635650595520391128533820
137294012600001742542762782842682942722542602382081464010400
TCRTA TripShot 2,680
1.64K3.36K0000001757053.36K3.18K2.81K3.20K2.64K2.94K3.12K3.36K2.70K3.32K3.19K2.56K2.04K851000
4751.12K000000004889679541.09K9731.06K1.04K1.12K9491.06K9454303150000
Tahoe Transportation District GMV 581
3679100000000105570690785505640910890660605535625545490255000
147364000000042228276314202256364356264242214250218196102000
Tahoe Transportation District 490
3668950000000105575725755500645895885655595545610565490245000
14635800000004223029030220025835835426223821824422619698000
Tehama 327
12830000000006026529225726230026529021028529120570100000
124400000000093944393540412832000000
Tracy 349
7521600000024362001641361241321241371491582161366800000
112800000012101402427242528222528231100000
Trinity 57
4320200000003910180359075110527075502024500000
None
Tuolumne Remix 350
1273150000000135235305210180185315225220240305245175700000
2425040000000012142244360474504504504504504504504434306216764
Turlock 1,460
7311.76K00000001.76K9401.35K1.14K1.04K1.19K1.14K8851.28K7401.14K1.10K1.35K1.14K1.35K000
90257000000000022820923822817725714822821922800000
UCSC 1,831
9622.64K03200000009001.08K1.22K1.23K1.40K1.68K2.64K2.12K1.20K1.12K1.36K1.09K1.28K1.41K1.15K1.04K853
127400048000000617893827685926894207400318320303294208223
Unitrans 5,109
8521.53K00000003251.39K1.26K1.39K1.39K1.39K1.28K1.48K1.48K1.53K1.50K1.48K1.36K1.22K93753348032
117264000000000203264264264229264264264264264238160000
VCTC GMV 7,474
6.11K11.6K000001902.76K7.46K9.82K9.78K10.0K10.3K10.1K10.4K10.6K11.1K11.6K10.7K10.2K9.23K7.69K3.46K1.19K17916
1.63K2.99K0000002811.57K2.47K2.62K2.81K2.91K2.93K2.90K2.93K2.95K2.99K2.93K2.86K2.64K2.13K91828740
Victor Valley GMV 5,367
4.15K7.26K00000354205.72K6.36K6.76K7.00K7.06K7.24K7.17K7.26K7.02K7.04K7.24K6.28K6.07K5.84K4.63K56000
1.11K2.59K00000471121.16K2.14K2.25K2.17K2.34K2.43K2.28K2.36K2.59K2.33K2.00K1.22K1.03K2784100
Victor Valley 5,138
4.03K7.07K00000354055.67K6.11K6.53K6.78K6.84K7.00K6.90K7.06K6.78K6.79K7.07K6.06K5.85K5.71K4.61K56500
1.03K2.24K0000000521.11K2.11K2.22K2.13K2.17K2.22K2.15K2.24K2.19K2.14K1.85K1.05K907148000
Visalia 4,479
3.70K6.88K00000004.28K5.38K6.72K6.88K6.70K6.64K6.45K5.72K5.36K5.45K5.48K5.30K5.48K5.08K4.50K3.22K2450
9402.22K00000001202331.78K2.17K2.21K2.22K2.07K2.10K2.10K2.02K2.06K2.03K1.23K17327000
YARTS 63
31115000005254035657575554020010305511560301000
124600000210161426303022168041222462412400
Yolobus 1,134
1.35K2.84K014000004601.96K2.70K2.31K1.95K1.88K1.88K1.69K1.97K1.99K1.94K2.42K2.84K1.90K1.24K1.18K800790475
4067400560000124280509733698634592584646664654668740635405308320316190
Yosemite Valley Shuttle 1,064
631000000000055901001001001001001001001001001001001001006015
254000000000223640404040404040404040404040246
Yuba-Sutter 1,202
30271400000030461714545525550536600529505580665624371100000
391000000000005710010010010010010010010066200000
Yuma 1,027
3307750000007526067054563565055555055560574577572042512025000
601410000005341059612412211111011112014113712174203000
eTrans 30
10600000000006020000602006020000000
None
GTFS scheduled stop_times.txt
GTFS specification